﻿CREATE TABLE [dbo].[Material] (
    [Id]               INT             IDENTITY (1, 1) NOT NULL,
    [Nombre]           VARCHAR (50)    NOT NULL,
    [Altura]           DECIMAL (10, 2) NULL,
    [Base]             DECIMAL (10, 2) NULL,
    [CodigoInventario] VARCHAR (50)    NULL,
    [CostoInventario]  MONEY           NULL,
    [Activo]           BIT             NOT NULL,
    [EmpresaId]        INT             NOT NULL,
    CONSTRAINT [PK_Material] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Material_Empresa] FOREIGN KEY ([EmpresaId]) REFERENCES [dbo].[Empresa] ([Id])
);

